package com.ybc.chinese.db;

/**
 * Created by ytzyg on 15/1/8.
 */
public class CacheTables implements CacheColumns, LogColumns {
    public String createSQL() {
        return "CREATE TABLE "
                + TAB_NAME + " ( "
                + COLUMN_ID + " INTEGER PRIMARY KEY, "
                + COLUMN_INDEX + " TEXT UNIQUE, "
                + COLUMN_CONTENT + " TEXT"
                + " );"
                ;
    }

    public String createLogSQL() {
        return "CREATE TABLE "
                + TAB_NAME_LOG + " ( "
                + COLUMN_ID_LOG + " INTEGER PRIMARY KEY, "
                + COLUMN_INDEX_LOG + " TEXT, "
                + COLUMN_CONTENT_LOG + " TEXT, "
                + COLUMN_STATUS_LOG + " INTEGER "
                + " );"
                ;
    }
}
